using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace DataModels.Models
{
    [Table("StockStatus")]
    public partial class StockStatu
    {
        [Key, Column(Order = 0, TypeName = "varchar")]
        [StringLength(50)]
        public string FacCode { get; set; }

        [Key, Column(Order = 1)]
        public DateTime ReportDate { get; set; }
        
        public int ReportYear { get; set; }
        public int ReportMonth { get; set; }

        /// <summary>
        /// The availalbe determine at the end of this month
        /// </summary>
        public int RequiredDetermine { get; set; }

        /// <summary>
        /// Available unigold at the end of this month
        /// </summary>
        public int RequiredUnigold { get; set; }

        /// <summary>
        /// Available DBS at the end of this month
        /// </summary>
        public int  RequiredDBS { get; set; }

        public Nullable<int> AvailableDetermine { get; set; }
        public Nullable<int> AvailableUnigold { get; set; }
        public Nullable<int> AvailableDBS { get; set; }
        public Nullable<System.DateTime> DateReportReceived { get; set; }
        

        // Navigation Property
        [ForeignKey("FacCode")]
        public virtual Facility Facility { get; set; }
    }
}
